| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
Id |
|
INTEGER |
NO |
|
| Code |
|
CHAR(10) |
NO |
|
| Name |
|
VARCHAR(40) |
NO |
|
| IsMinPctAttendanceRequired |
|
BIT |
NO |
|
| MinPctAttendance |
|
NUMERIC(8, 2) |
NO |
|
| IsMinHoursAttendanceRequired |
|
BIT |
NO |
|
| MinHoursAttended |
|
NUMERIC(9, 2) |
NO |
|
| IsMinNumericAvgRequired |
|
BIT |
NO |
|
| MinNumericAverage |
|
NUMERIC(11, 6) |
NO |
|
| IsMinCumulativeGpaRequired |
|
BIT |
NO |
|
| MinCumulativeGPA |
|
NUMERIC(18, 6) |
NO |
|
| IsMinHoursCreditsScheduledRequired |
|
BIT |
NO |
|
| MinClockHoursScheduled |
|
NUMERIC(18, 2) |
NO |
|
| MinCreditHoursScheduled |
|
NUMERIC(18, 2) |
NO |
|
| IsMinHoursCreditsCompletedRequired |
|
BIT |
NO |
|
| MinClockHoursCompleted |
|
NUMERIC(18, 2) |
NO |
|
| MinCreditHoursCompleted |
|
NUMERIC(18, 2) |
NO |
|
| IsFaCreditsHoursEarnedAttemptedRequired |
|
BIT |
NO |
|
| FaCreditsHoursEarnedAttemptedFlag |
|
CHAR(1) |
NO |
|
| IsMaxDaysAfterStudentLdaRequired |
|
BIT |
NO |
|
| MaxDaysAfterStudentLda |
|
INTEGER |
NO |
|
| IsMissingDocumentsChecked |
|
BIT |
NO |
|
| IsStudentSchoolStatusChecked |
|
BIT |
NO |
|
| IsMeetingSapRequired |
|
BIT |
NO |
|
| RequiredStudentSap |
|
CHAR(8) |
NO |
|
| IsIsirOnFileRequired |
|
BIT |
NO |
|
| IsAcceptedOriginationRequired |
|
BIT |
NO |
|
| IsVerificationStatusChecked |
|
BIT |
NO |
|
| VerificationStatus |
|
VARCHAR(25) |
NO |
|
| IsMaxDisbursementAmountDifferenceChecked |
|
BIT |
NO |
|
| MaxDisbursementAmountDifference |
|
MONEY(19, 4) |
NO |
|
| IsMaxDaysPriorTermStartDateChecked |
|
BIT |
NO |
|
| MaxDaysPriorTermStartDate |
|
INTEGER |
NO |
|
| IsFirstTimeBorrowerRule |
|
BIT |
NO |
|
| IsMaxDaysFromLoanPeriodEndDateChecked |
|
BIT |
NO |
|
| MaxDaysFromLoanPeriodEndDate |
|
INTEGER |
NO |
|
| IsActive |
|
BIT |
NO |
|
LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| IsEnrollmentToPackageStatusRequired |
|
BIT |
NO |
|
| IsEvaluationByTerm |
|
BIT |
NO |
|
| IsAttendanceAllCoursesEvaluated |
|
BIT |
NO |
|
| IsDocumentCompletionDateConfirmed |
|
BIT |
NO |
|
| IsOriginationCertifiedBeforeLda |
|
BIT |
NO |
|
| IsResidencyStateChecked |
|
BIT |
NO |
|
| ResidencyState |
|
CHAR(2) |
YES |
|
| IsStateResidentSinceChecked |
|
BIT |
NO |
|
| ResidencyStateYears |
|
SMALLINT |
YES |
|
| BachelorsDegree |
|
CHAR(1) |
NO |
|
| GraduateLevelProgram |
|
CHAR(1) |
NO |
|
| IsEntranceInterviewRequired |
|
BIT |
NO |
|
MinEnrollmentStatusId |
|
INTEGER |
YES |
|
| IsMinPaymentPeriodHoursAttendedRequired |
|
BIT |
NO |
|
| MinPaymentPeriodHoursAttended |
|
NUMERIC(9, 2) |
NO |
|
| Check Constraint Name |
CheckConstraint |
| Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched |
([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0)) |
| Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp |
([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0)) |
| Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg |
([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0) |
| Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt |
([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0) |
| Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt |
([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0) |
| Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA |
([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0) |
| Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA |
([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0) |
| Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate |
([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0) |
| Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt |
([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0) |